UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xu6Vgr/3yLUvRfin4GrPssT5suOkzMJ9jvuZKjvWrrw='
WHERE
key_id = '653752f6ac81b06cce40b60a401fd9b9a5506f6d33f1be186ff71acb7ad34329'
AND (
token = 'xu6Vgr/3yLUvRfin4GrPssT5suOkzMJ9jvuZKjvWrrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)