UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H0zY2GTXpmq5JNEs4/oUOlt2Vs5Hq1T0/KwUAvcvp14='
WHERE
key_id = 'b2c2369f7c5b60d123d211bc66c023fa11a87ddfe75857fab27ab8b1bb24bb43'
AND (
token = 'H0zY2GTXpmq5JNEs4/oUOlt2Vs5Hq1T0/KwUAvcvp14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)