UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XjzCpDpyIjlGHertG52rUIf9axuFQ9kNRyWnnnj9xtw=' 
WHERE 
  key_id = 'cf407278f5a5068607fff3b52409a984f41e71ea9958e40c386b7d819b437e3a' 
  AND (
    token = 'XjzCpDpyIjlGHertG52rUIf9axuFQ9kNRyWnnnj9xtw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040