UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BGzHPJM1Jvf3yxJN8fBmFB1LN8FmMVUbc7G0p6jgJBI='
WHERE
key_id = 'f17bf180718bdefcfc885d641ee1e4fa7185f6b338469afefd0d71b2b196b8b9'
AND (
token = 'BGzHPJM1Jvf3yxJN8fBmFB1LN8FmMVUbc7G0p6jgJBI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)