UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+NFpa2q7H8v6P1KhBKbnKckq9KhttktsLAy5lOVt1fI='
WHERE
key_id = '7a54050d19d8a9902b26914e94dc827c81d91443f0e806be6b34ce1e57762171'
AND (
token = '+NFpa2q7H8v6P1KhBKbnKckq9KhttktsLAy5lOVt1fI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)