UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1LHO+8ZHJ8q7UuQrmJ4G6sV00nrkN6x4TYxp8a+miUY='
WHERE
key_id = 'ec4a6ec93b6cc87b5a9b8dd687b749a26ea4133e34ecf48345aad6349c61b05c'
AND (
token = '1LHO+8ZHJ8q7UuQrmJ4G6sV00nrkN6x4TYxp8a+miUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)