UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0X1oyKHMYqqSyVJT3qaZF2LDh0HUx+Bn/bNIWjg/Y5Y='
WHERE
key_id = 'e59be7ae09df5d6600c2f9cf3b0aa30703ff7139930df7334a2531518bd74661'
AND (
token = '0X1oyKHMYqqSyVJT3qaZF2LDh0HUx+Bn/bNIWjg/Y5Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)