UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0YXa4S8QTKJasdHu3lt1s33WyxTvEGDP6hRYhAi0ZJo='
WHERE
key_id = '08b6fe5322866b3d196c776830379b994103221a389fcee8d56ff011d96cc8b1'
AND (
token = '0YXa4S8QTKJasdHu3lt1s33WyxTvEGDP6hRYhAi0ZJo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)