UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/CVYdlR2yUeP2XmvR3XCsn1Ch56lhF6QW1/R1jZ8IGo=' 
WHERE 
  key_id = '13a706d2bd737b62425126cdd68e08a4a3c3687326fddf68fc06be1e2fec413d' 
  AND (
    token = '/CVYdlR2yUeP2XmvR3XCsn1Ch56lhF6QW1/R1jZ8IGo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041