UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3V9zeSyHCE6wUQXOCAIXs9KSu0yXY/dUqkjyOdPbxnk='
WHERE
key_id = 'd2c70c267cd0f327614b21175a532788955c8578de1b271798744ccd684a1289'
AND (
token = '3V9zeSyHCE6wUQXOCAIXs9KSu0yXY/dUqkjyOdPbxnk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)