UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lqDmIgcVdVS60d3xBqb/mk44XFWhpCQT/3zasqCuhvM='
WHERE
key_id = '3f241e178615550413c124d2aefdea4ba128f7bb23cae4f57304b7a2fbf49e1f'
AND (
token = 'lqDmIgcVdVS60d3xBqb/mk44XFWhpCQT/3zasqCuhvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)