UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XNMmEkzEUA7TgMm6UD/4PM7XTeeQoq1IeJq8cG7tXs8='
WHERE
key_id = '38ceba43d8e42044df453eaa48b7ba301aa5d2060a9cc70ea1cb7f0eff3f7100'
AND (
token = 'XNMmEkzEUA7TgMm6UD/4PM7XTeeQoq1IeJq8cG7tXs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)