UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bPeNZqOvvyAQjqQrF99i9URgmEWV0CUZLRlLWXLspzw='
WHERE
key_id = '4118afc1b44961f245675490cd9d3e3378e81b01e85ca5365ed69b6f78623a44'
AND (
token = 'bPeNZqOvvyAQjqQrF99i9URgmEWV0CUZLRlLWXLspzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)