UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MbHJtOn3vvBRmCVd5mESYI2a8B15Yaekw63A1khAsn8='
WHERE
key_id = '9e1180a7ecdc8ca9a53a3f63020a3ff8cdc1df3029366406650bee268ef16b61'
AND (
token = 'MbHJtOn3vvBRmCVd5mESYI2a8B15Yaekw63A1khAsn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)