UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZcJK6IuX7tHZJzxL7Q/MO2wQA6Et8zw21rG5Js3pbAk=' 
WHERE 
  key_id = 'cd7a2960602ef1fa29595d11ee9d78d5d3257068f1b2f5de1ac8e2f737d1ae7e' 
  AND (
    token = 'ZcJK6IuX7tHZJzxL7Q/MO2wQA6Et8zw21rG5Js3pbAk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029