UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p5ksMb63h0qzFOMLYu9wGKYivU2SzU8wa9rdOLnqMSo='
WHERE
key_id = '4ee81c4b77d9a57bef72a6fb6448aef43e1bd9897f8a05ec0606d55a853a3ff9'
AND (
token = 'p5ksMb63h0qzFOMLYu9wGKYivU2SzU8wa9rdOLnqMSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)