UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kfNkeUW+5QT7k56HYvmJA51kdvdaYeGzc0vB7cb4dRg='
WHERE
key_id = '793e344fe87008cc1ac26b5701f62418c5fa6349cf80a1a9f20a64df61d5a4eb'
AND (
token = 'kfNkeUW+5QT7k56HYvmJA51kdvdaYeGzc0vB7cb4dRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)