UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Q2oA/7eyyIrrLagXEgPy5FYifJn309OxfACW9R4o6k='
WHERE
key_id = '3e4d221fd0df3514bb8cf0c919ce06daa0ac461c57ecf00d49f8cdcd7039e906'
AND (
token = '8Q2oA/7eyyIrrLagXEgPy5FYifJn309OxfACW9R4o6k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)