UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kD+pypDoAiTo9+BKuqAHMRbraFrGD1MXWvRjPZLDklE='
WHERE
key_id = '3a9a62caefcbb42b8d282e5d3f01a34b7eccc916ce32ec7cbc054d7a31d9449a'
AND (
token = 'kD+pypDoAiTo9+BKuqAHMRbraFrGD1MXWvRjPZLDklE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)