UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ju4mXgfR9YGeXhxW7JlILZw/0sIQf7qTb2cfFApo1Uw=' 
WHERE 
  key_id = 'f7e9759591b38cf1c695c0c5676d137ddaa7c5b372bebe2a26e5c489809f9b45' 
  AND (
    token = 'ju4mXgfR9YGeXhxW7JlILZw/0sIQf7qTb2cfFApo1Uw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023