UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xAoRyY7ancEN8b6g+BtMB07L5ZUzYMsg/foEjjsAZws='
WHERE
key_id = '8cc9268d8dd06f47f1c9bf5e584198d17a665306cc07a3b2f0a535da3fb9fb34'
AND (
token = 'xAoRyY7ancEN8b6g+BtMB07L5ZUzYMsg/foEjjsAZws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)