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