UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L//iJ6xuF1C7elFL5NMuddJqxjm9w6VxHbifTX1VnUk='
WHERE
key_id = 'cf42d1d1f55b4c94744ac337156767d5bebe917311e80fd5e9eaedceeb6e8fd5'
AND (
token = 'L//iJ6xuF1C7elFL5NMuddJqxjm9w6VxHbifTX1VnUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)