UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9K0kV27pVdcaMJ61nVjVuSxPZx4ASE0d3NU6mlQe0cc='
WHERE
key_id = '0a9a6e5006562fc0613182d8ac3c96f9ef07d10b172c57a6af8d3a2e85ef3c29'
AND (
token = '9K0kV27pVdcaMJ61nVjVuSxPZx4ASE0d3NU6mlQe0cc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)