UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TKHwYw68XIgrnOOm5p/lxqH9Cv3w0MEMohRQ3ZEbZV4=' 
WHERE 
  key_id = 'a1e97e6771f3664ccf9cc0549da6a5ff42d6e7e126f533d9e28a6bcafcce9583' 
  AND (
    token = 'TKHwYw68XIgrnOOm5p/lxqH9Cv3w0MEMohRQ3ZEbZV4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042