UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9G46n+Bj8lRK1IZnZjob/Zdzt+jwEOkRULRq5siUW68='
WHERE
key_id = '1968a6f10ae621967fefbfdc2663528905ecf21282ffb69eb94d55bbab2113f4'
AND (
token = '9G46n+Bj8lRK1IZnZjob/Zdzt+jwEOkRULRq5siUW68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)