UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KJdlP+CZLMvrY2LfFWBfUorl2tFXZZejh5I/fCpB/nI='
WHERE
key_id = 'd2478a350cfd79b4a46baeb6e53b1f9a63887101a70c94776c6270f17751e0c0'
AND (
token = 'KJdlP+CZLMvrY2LfFWBfUorl2tFXZZejh5I/fCpB/nI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)