UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UqqfUrlWyN8cc7/M4OPYUBFgIqlywxMADXm++20QDNw=' 
WHERE 
  key_id = 'd67f27ac1b0e973f7a7b7aa5efd5f71b24ab206649c8aaf0b14672dd24c83536' 
  AND (
    token = 'UqqfUrlWyN8cc7/M4OPYUBFgIqlywxMADXm++20QDNw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024