UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AAH204tJJKriK5kZbIVA2j4BMZa7kwkZ4+b033Gc/Tc='
WHERE
key_id = 'a2f2cdf10cf436f7b1d8fb57ce498894221bba5913aea04e59228ca37d3bd152'
AND (
token = 'AAH204tJJKriK5kZbIVA2j4BMZa7kwkZ4+b033Gc/Tc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)