UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vnWLz5XeRU+ZaTGjno/TQtTixsXbiu+qWobI864jiCI='
WHERE
key_id = '24e498f1436f7bcd26edb538a9db278d4b817a38d5e826f03b69d73b8c64ff56'
AND (
token = 'vnWLz5XeRU+ZaTGjno/TQtTixsXbiu+qWobI864jiCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)