UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rRe5HdtzCbqVkneRo5undVsLJcGXPA4n75VsmKyG4mk='
WHERE
key_id = '6cfefb070f54b86dc9c074f5fd0679614ca9e4b97d9a68af4fbffcfe3e46fbf9'
AND (
token = 'rRe5HdtzCbqVkneRo5undVsLJcGXPA4n75VsmKyG4mk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)