UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cbA0TyxHgaMca36oQ402TAQqkVXB+3LIgbC4fjDXOIs='
WHERE
key_id = 'b57464713ecb26c0ccd3fc9721ee3d358b30f05945c8f9ee8370ae69c86cafc7'
AND (
token = 'cbA0TyxHgaMca36oQ402TAQqkVXB+3LIgbC4fjDXOIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)