UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ihJrlfI8KoCXG7hdJDagxpSZ96VQlz/mBlCuFNOI8Gk='
WHERE
key_id = '24801e0a87171bc7d8ddb422cf3fd43b53c9371cd607b632b770be120de4a7c6'
AND (
token = 'ihJrlfI8KoCXG7hdJDagxpSZ96VQlz/mBlCuFNOI8Gk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)