UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C7H6T/vFykL9uFbhPYx/0Qlo0CLG2Xb033gfoZtsMto='
WHERE
key_id = '8f9ac42cc5ad9619c56fc7ee2a15a7828ad0de24a587db5535d8d696301be097'
AND (
token = 'C7H6T/vFykL9uFbhPYx/0Qlo0CLG2Xb033gfoZtsMto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)