UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'edyh2GvZyv6DkwMQ/a+y4CQ22J8QI8qO91ymHfEBJyY=' 
WHERE 
  key_id = 'd9757eaece551d0c3064221d168a920cfe7c3599b80551d1e7d2bd07412970ab' 
  AND (
    token = 'edyh2GvZyv6DkwMQ/a+y4CQ22J8QI8qO91ymHfEBJyY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031