UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8oKMiritLPa5kqNfgTAHjQh9rg3llqfngTXFB+abE3o='
WHERE
key_id = 'acfa12257216a355f54277d5b4078d4b7432ba327c1d9b8f594c623743e35266'
AND (
token = '8oKMiritLPa5kqNfgTAHjQh9rg3llqfngTXFB+abE3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)