UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UBHs6XKCveSX+aVOcYgFeeG5yJr10QvMAJ9pfsSzyas='
WHERE
key_id = '4f4a63969998b7d6bde6f89936c192ae3b9c8aeac1f9895d7e26afdd4397619e'
AND (
token = 'UBHs6XKCveSX+aVOcYgFeeG5yJr10QvMAJ9pfsSzyas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)