UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zFlg72Gg6epcGvBPSF4LWvnxz0NveTl0VpjOY1MYZA4='
WHERE
key_id = 'fb19e40b130fb5bdf097f88e9faa0fba8c0cb291167367bfe96404a6e0790c9a'
AND (
token = 'zFlg72Gg6epcGvBPSF4LWvnxz0NveTl0VpjOY1MYZA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)