UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dIQCYMX5kt9RSj643A8c6mEldTfPWBEGYYnxE4Cng/A='
WHERE
key_id = '9d5a380cf6d6a7b95379cf1a97c17e969255e74dd8c12321ac2d0b3b7234e39a'
AND (
token = 'dIQCYMX5kt9RSj643A8c6mEldTfPWBEGYYnxE4Cng/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)