UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oBqo0sOuz+D1zuyv647Lh7On+jNMp3L+BC7WE+wa3lE=' 
WHERE 
  key_id = '44818f14000f22bdb7b7fdd32be8e8a9694207a8cf8f78800fd2f0e695c416da' 
  AND (
    token = 'oBqo0sOuz+D1zuyv647Lh7On+jNMp3L+BC7WE+wa3lE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045