UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i1uOyO/5/BsYfJcSXTYctv0bMjaAmxv8I0uRCOLfIuc='
WHERE
key_id = '7b4a29627df8ad1b2c243b69a81a304ac7651f32ce75ab845aac63d8470c0e89'
AND (
token = 'i1uOyO/5/BsYfJcSXTYctv0bMjaAmxv8I0uRCOLfIuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)