UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zXzqCkFTSAZfI5L7iURaG7u6WQk09EJ/aZxySeAJgDk='
WHERE
key_id = '197573e5045dfda2454eadec1e0222af4affeb1c5313dd6aaf58e6a3d903b364'
AND (
token = 'zXzqCkFTSAZfI5L7iURaG7u6WQk09EJ/aZxySeAJgDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)