UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4jC0V5vuH4i9fROuQlKk+85miaeDT4VZ6u1PJ+7/MXw='
WHERE
key_id = '86ca28dd168c4dc6c66c3bd10a429ef749e584cb163c20d131e2c8bc712373f5'
AND (
token = '4jC0V5vuH4i9fROuQlKk+85miaeDT4VZ6u1PJ+7/MXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)