UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GnwL2gfh2DeHSVumWWC0k+ZW7rKsMIxPloHVXFv6ox4='
WHERE
key_id = '9d1732808836ea00e22e3c267bf9a0489df78a95918b467f54a16325b5e7ed97'
AND (
token = 'GnwL2gfh2DeHSVumWWC0k+ZW7rKsMIxPloHVXFv6ox4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)