UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RUd5QC7l7mDvkul+r0k+yXrtPR77KKRGOnfE0mqTOb0=' 
WHERE 
  key_id = 'cbde4bd60ab800a7ce58e5e51ce667a109651b4cda2b4312d742b49193fbc6fa' 
  AND (
    token = 'RUd5QC7l7mDvkul+r0k+yXrtPR77KKRGOnfE0mqTOb0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029