UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kzwPkfh5WdOsOUm7Rgjv+svPYv4v3XjgLJLsnAfqaJM='
WHERE
key_id = 'bb24d164bc2b515f303660a11d8a044c141566efcba1e7e513e9234ef3fde12d'
AND (
token = 'kzwPkfh5WdOsOUm7Rgjv+svPYv4v3XjgLJLsnAfqaJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)