UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vHMrdsDdZsvUO3KHmTZDJ2jhLQOZQhH4i5YyketKTjw='
WHERE
key_id = '3924eeacf1f56acbf9538e44efb64aad4cc9a7604240f118b7d1d7c6a3c6a7c5'
AND (
token = 'vHMrdsDdZsvUO3KHmTZDJ2jhLQOZQhH4i5YyketKTjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)