UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hK0xK2J5n10EquyfJLG9tV1FDFOb2y/GWJmgV5eANvk='
WHERE
key_id = '7d316b8a3bfa20e8dc00b17efa287e9e5bdaf0f975a8b18ac2e9d44b758511c2'
AND (
token = 'hK0xK2J5n10EquyfJLG9tV1FDFOb2y/GWJmgV5eANvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)