UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '58uLYov89BXbILet24GfBw77DqS0X8eX2MOtWi1NX9M=' 
WHERE 
  key_id = '8f0b614218673b0e30a8224a58073676aa4e2d2cc469b7cda4ed4f444e4223ce' 
  AND (
    token = '58uLYov89BXbILet24GfBw77DqS0X8eX2MOtWi1NX9M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00059