UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2mLCH4HXcRG1QKTudG0SPpidKpLYUiJwMgv3eWu9ads='
WHERE
key_id = '0236efa4c5054d9e90a7c864086aeffa316eeb1108af82f99cf6c38290af12d5'
AND (
token = '2mLCH4HXcRG1QKTudG0SPpidKpLYUiJwMgv3eWu9ads='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)