UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5lx0CqAH8oOIJDUqEXUPaGlyhqoLK3lKAreaw0COXAM='
WHERE
key_id = '747cb60c95fc9d3a00f60eac0590efbe7e3e3c51458777a51c2b632cf31782d2'
AND (
token = '5lx0CqAH8oOIJDUqEXUPaGlyhqoLK3lKAreaw0COXAM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)