UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xY9Txn1vI7jtGE6SU/9z1I/QVddx/MHn0gUnMKo/RFI=' 
WHERE 
  key_id = 'c559cc10274c92e685ebe1b3d116784cf2079bcdb54e273e14ec8ef2eaca3152' 
  AND (
    token = 'xY9Txn1vI7jtGE6SU/9z1I/QVddx/MHn0gUnMKo/RFI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026